Release 10.1A: OpenEdge Data Management:
Database Administration

PROUTIL DBANALYS qualifier

Displays statistical information about index, record, and free chain blocks.

Syntax

proutil db-name -C dbanalys

Parameters

db-name

Specifies the database you are using.

Example

The following output is a sample display of PROUTIL DBANALYS:

SUMMARY FOR AREA "Inventory" : 8 ----------------------------------------------------------                      Records             Indexes                  Combined  NAME                Size   Tot %       Size   Tot %              Size  Tot % PUB.Bin             26.3K    1.1       16.4K    0.7             42.8K    1.8 PUB.InventoryTrans  3661B    0.1          0B    0.0             3661B    0.1 PUB.Item            7662B    0.3       8117B    0.3            15779B    0.6 PUB.POLine         217.5K    9.1       51.9K    2.2            269.4K   11.3 PUB.PurchaseOrder   68.6K    2.9       19.0K    0.8             87.6K    3.7 PUB.Supplier        1177B    0.0         97B    0.0             1274B    0.1 PUB.SupplierItemXr  1118B    0.0       1166B    0.0             2284B    0.1 PUB.Warehouse       1288B    0.1        440B    0.0             1728B    0.1 Size key:  B = bytes  K = kilobytes  M = megabytes  G = gigabytes